Release 10.1A: OpenEdge Data Management:
Database Administration

PROSHUT command

Shuts down the OpenEdge database server and individual processes. Before you shut down the broker, have all application users quit their sessions. If necessary, you can disconnect users by using the PROSHUT command’s Disconnect a User or Unconditional Shutdown parameters.

Syntax

proshut db-name [ -b | -by| -bn                 | -C list | -C disconnect username                 | -F | -Gw                 | -H host-name | -S service-name                 | -cpinternal codepage | -cpstream codepage                 ] ...

Parameters

db-name

Specifies the database the server is running against.

-b

Directs PROSHUT to perform a batch shutdown. When no client is connected, the database automatically shuts down. When one or more clients are connected, PROSHUT prompts the user to enter “yes” to perform an unconditional batch shutdown and to disconnect all active users; or “no” to perform a batch shutdown only if there are no active users. The -b parameter combines the functionality of the -by or -bn parameters.

-by

Directs PROSHUT to perform an unconditional batch shutdown and to disconnect all active users. Note that PROSHUT does not give users any notice before disconnecting them.

-bn

Directs PROSHUT to perform a batch shutdown only if there are no active users.

-C list

Lists all of the users connected to the database. The list is printed out to the screen without any page breaks.

-C disconnect usernum

Allows you to initiate a disconnect for the specified user. This is similar to option 1 of the PROSHUT menu.

-F

Starts an emergency shutdown. To use this parameter, you must run PROSHUT on the machine where the server resides. This parameter is not applicable for remote shutdowns or DataServer shutdowns.

-Gw

For DataServers, specifies the DataServer broker to shut down.

-H host-name

Specifies the machine where the database server runs. If issuing the shutdown command from a remote machine, specify the host name.

-S service-name

Specifies the database server or broker process. If issuing the shutdown command from a remote machine, specify the service name.

-cpinternal codepage

An internationalization startup parameter that identifies the code page used in memory.

-cpstream codepage

An internationalization startup parameter that identifies the code page used for stream I/O.

When you enter the PROSHUT command without the -by, -bn, or -F parameters, the following menu appears:

1 Disconnect a User 2 Unconditional Shutdown 3 Emergency Shutdown (Kill All) x Exit

The following table lists the menu options and their actions:

Option	Action
1	Prompts you for the number of the user you want to disconnect.
2	Disconnects all users and shuts down the database.
3	Prompts you to confirm your choice. If you cancel the choice, you cancel the shutdown. If you confirm the choice, PROSHUT displays the following message: Emergency shutdown initiated... PROSHUT marks the database for abnormal shutdown, kills all remaining processes connected to the database, and deletes shared-memory segments and semaphores. The database is in a crashed state. PROSHUT performs normal crash recovery when you restart the database and backs out any active transactions.
x	Cancels the shutdown without taking any action.

Notes

You can shut down using the PROMON utility’s Shut Down Database menu option.
The user who shuts down the server must have started it, or be root (on UNIX).
When you initiate PROSHUT over a network, the amount of time that it takes to actually shut down all of the OpenEdge processes and to free any ports varies depending on the number of clients, brokers, and servers that must be shut down. The PROSHUT command might return control to the terminal before all of the processes are stopped and resources are freed.
If you specified a unique value for -cpinternal or -cpstream when you opened the database, you must specify that same value for -cpinternal or -cpstream when you close the database with the PROSHUT command. If you do not, PROSHUT uses the values for -cpinternal and -cpstream found in the main startup parameter file created during installation (such as DLC/startup.pf). If the values of -cpinternal or -cpstream specified for your database do not match the values specified in the main startup parameter file, you receive the following error message:

Code page conversion table for table-name to table-name was not found. (6063)

Unconditional forced shutdown (-byF) is not allowed on a database started with no integrity (-i).
Forced shutdown (-F) on a database started with no integrity (-i) requires two confirmations. The first confirmation requires you to acknowledge that the database was started with no integrity and you are initiating a forced shutdown. The second confirmation is the normal forced shutdown confirmation. You must answer y to both for the shutdown to execute. This type of shutdown can cause database corruption.